home *** CD-ROM | disk | FTP | other *** search
/ InterCD 2001 January / january_2001.iso / intercd / root / ^4Developers / VB / visbasdb / VBDB / VBDB Code / VB6 Code / Class 6 / Example6-3DE.frm (.txt) < prev    next >
Encoding:
Visual Basic Form  |  1999-09-14  |  4.9 KB  |  167 lines

  1. VERSION 5.00
  2. Begin VB.Form frmAuthors 
  3.    BorderStyle     =   1  'Fixed Single
  4.    Caption         =   "Authors"
  5.    ClientHeight    =   2625
  6.    ClientLeft      =   45
  7.    ClientTop       =   330
  8.    ClientWidth     =   4680
  9.    LinkTopic       =   "Form1"
  10.    MaxButton       =   0   'False
  11.    MinButton       =   0   'False
  12.    ScaleHeight     =   2625
  13.    ScaleWidth      =   4680
  14.    StartUpPosition =   3  'Windows Default
  15.    Begin VB.CommandButton cmdDone 
  16.       Caption         =   "Do&ne"
  17.       Height          =   375
  18.       Left            =   3240
  19.       TabIndex        =   13
  20.       Top             =   2160
  21.       Width           =   1215
  22.    End
  23.    Begin VB.CommandButton cmdDelete 
  24.       Caption         =   "&Delete"
  25.       Height          =   375
  26.       Left            =   1680
  27.       TabIndex        =   12
  28.       Top             =   2160
  29.       Width           =   1215
  30.    End
  31.    Begin VB.CommandButton cmdEdit 
  32.       Caption         =   "&Edit"
  33.       Height          =   375
  34.       Left            =   120
  35.       TabIndex        =   11
  36.       Top             =   2160
  37.       Width           =   1215
  38.    End
  39.    Begin VB.CommandButton cmdCancel 
  40.       Caption         =   "&Cancel"
  41.       Height          =   375
  42.       Left            =   3240
  43.       TabIndex        =   10
  44.       Top             =   1680
  45.       Width           =   1215
  46.    End
  47.    Begin VB.CommandButton cmdSave 
  48.       Caption         =   "&Save"
  49.       Height          =   375
  50.       Left            =   1680
  51.       TabIndex        =   9
  52.       Top             =   1680
  53.       Width           =   1215
  54.    End
  55.    Begin VB.CommandButton cmdAddNew 
  56.       Caption         =   "&Add New"
  57.       Height          =   375
  58.       Left            =   120
  59.       TabIndex        =   8
  60.       Top             =   1680
  61.       Width           =   1215
  62.    End
  63.    Begin VB.CommandButton cmdNext 
  64.       Caption         =   "Next =>"
  65.       Height          =   255
  66.       Left            =   2520
  67.       TabIndex        =   7
  68.       Top             =   1320
  69.       Width           =   1215
  70.    End
  71.    Begin VB.CommandButton cmdPrevious 
  72.       Caption         =   "<= Previous"
  73.       Height          =   255
  74.       Left            =   1080
  75.       TabIndex        =   6
  76.       Top             =   1320
  77.       Width           =   1215
  78.    End
  79.    Begin VB.TextBox txtYearBorn 
  80.       DataField       =   "Year Born"
  81.       DataMember      =   "comAuthors"
  82.       DataSource      =   "denBooks"
  83.       Height          =   285
  84.       Left            =   1200
  85.       Locked          =   -1  'True
  86.       TabIndex        =   3
  87.       Text            =   "Text3"
  88.       Top             =   840
  89.       Width           =   1215
  90.    End
  91.    Begin VB.TextBox txtAuthor 
  92.       DataField       =   "Author"
  93.       DataMember      =   "comAuthors"
  94.       DataSource      =   "denBooks"
  95.       Height          =   285
  96.       Left            =   1200
  97.       Locked          =   -1  'True
  98.       TabIndex        =   2
  99.       Text            =   "Text2"
  100.       Top             =   480
  101.       Width           =   3375
  102.    End
  103.    Begin VB.TextBox txtAuthorID 
  104.       DataField       =   "Au_ID"
  105.       DataMember      =   "comAuthors"
  106.       DataSource      =   "denBooks"
  107.       Height          =   285
  108.       Left            =   1200
  109.       Locked          =   -1  'True
  110.       TabIndex        =   1
  111.       Text            =   "Text1"
  112.       Top             =   120
  113.       Width           =   1215
  114.    End
  115.    Begin VB.Label Label3 
  116.       Caption         =   "Year Born"
  117.       Height          =   255
  118.       Left            =   120
  119.       TabIndex        =   5
  120.       Top             =   840
  121.       Width           =   1215
  122.    End
  123.    Begin VB.Label Label2 
  124.       Caption         =   "Author Name"
  125.       Height          =   255
  126.       Left            =   120
  127.       TabIndex        =   4
  128.       Top             =   480
  129.       Width           =   1215
  130.    End
  131.    Begin VB.Label Label1 
  132.       Caption         =   "Author ID"
  133.       Height          =   255
  134.       Left            =   120
  135.       TabIndex        =   0
  136.       Top             =   120
  137.       Width           =   1215
  138.    End
  139. Attribute VB_Name = "frmAuthors"
  140. Attribute VB_GlobalNameSpace = False
  141. Attribute VB_Creatable = False
  142. Attribute VB_PredeclaredId = True
  143. Attribute VB_Exposed = False
  144. Option Explicit
  145. Private Sub cmdDelete_Click()
  146. Dim Response As Integer
  147. Response = MsgBox("Are you sure you want to delete this record?", vbYesNo + vbQuestion + vbDefaultButton2, "Delete")
  148. If Response = vbNo Then
  149.   Exit Sub
  150. End If
  151. End Sub
  152. Private Sub cmdNext_Click()
  153. denBooks.rscomAuthors.MoveNext
  154. If denBooks.rscomAuthors.EOF Then
  155.   denBooks.rscomAuthors.MoveLast
  156. End If
  157. End Sub
  158. Private Sub cmdPrevious_Click()
  159. denBooks.rscomAuthors.MovePrevious
  160. If denBooks.rscomAuthors.BOF Then
  161.   denBooks.rscomAuthors.MoveFirst
  162. End If
  163. End Sub
  164. Private Sub cmdSave_Click()
  165. MsgBox "Record saved.", vbOKOnly + vbInformation, "Save"
  166. End Sub
  167.